package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.TbLog;
import com.ruoyi.system.Fdongbei.domain.TbYcXccl;
import com.ruoyi.system.Fdongbei.mapper.provider.TbLogSqlProvider;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2025-02-04
 */
public interface TbYcXcclMapper {


//    @Select(" select * from tb_yc_xccl where czbh =  #{sql} ")
//    List<TbYcXccl> selectxccl(@Param("sql") String sql);


    @SelectProvider(type = TbLogSqlProvider.class, method = "selectxccl")
    List<TbYcXccl>selectxccl(@Param("sql") String sql);

    @Insert(" insert tb_yc_xccl (czbh , dz , dpd , dpg ) " +
            "values( #{czbh},#{dz},#{dpd},#{dpg} )")
    int insertxccl(TbYcXccl tbYcXccl);

    @Select(" select top(1)* from tb_yc_xccl where czbh = #{czbh} ")
    TbYcXccl selectbyczbh(String czbh );


    @Update(" update tb_yc_xccl set dz = #{dz},dpd = #{dpd},dpg = #{dpg} where czbh = #{czbh} ")
    int updatexccl(TbYcXccl tbYcXccl);

    @Delete(" delete from tb_yc_xccl where czbh = #{czbh} ")
    int deletexccl(String czbh );

}
